{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["CP04.2024","Fornecedores","RefParts II","RefParts","Fornecedores II","Input"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CP04.2024","index":0,"n_rows":16,"n_cols":32,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,1,0,5],[0,6,0,13],[0,14,0,31]]}
[null,"Códigos dos artigos por empresa",null,null,null,null,"Condições a carregar no arcodo",null,null,null,null,null,null,null,"Outras ordens a criar nos artigos além da do acordo"]
["Descrição","BT","RL","EVA","RA","TEJO","FORNECEDOR","NIF","ordem","Marca","Referência","P Un","Data inicio","Data de fim","FORNECEDOR","NIF","ordem","Marca","Referência","P Un","FORNECEDOR","NIF","ordem","Marca","Referência","P Un","FORNECEDOR","NIF","ordem","Marca","Referência","P Un"]
["BATERIA","007720006","007720063","007720014 ","007720063\n007760010","007720063","MOTORBUS",503500992,32,"HELLA","HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS",503500992,33,"NEWONEDRIVE",500662860,33]
["BATERIA","007720063",null,"007720022","007720048",null,"GLOBAL P",509436722,32,"Yuasa","YBX3017",74.299200000000013,"2024-08-20","2999-12-31","GLOBAL P",509436722,33,"VARTA","VAR-595402080",84.942099999999996,"NEWONEDRIVE",500662860]
["BATERIA",null,null,null,"007720170 ",null,"GLOBAL P",509436722,31,"Yuasa","YBX3019",77.689399999999992,"2024-08-20","2999-12-31","NASACAR",500615250,32,"VOLTHOR - TAB","0330130/929 - VS11H",99.15,"KRAULTI",502271450,33,"YUASA","YBX3019",102.26]
["BATERIA","007720089","007720204","007720048\n007710049","007740020\n007740129","00772097","MOTORBUS",503500992,32,"HELLA","HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS",503500992,33,"Yuasa","YBX1629",130.51580000000001]
["BATERIA",null,"007721004",null,null,null,"GLOBAL P",509436722,31,"Yuasa","YBX5625",190.49979999999999,"2024-08-20","2999-12-31","MOTORBUS",503500992,32,"TUDOR","TE2353",192.864,"NEWONEDRIVE",500662860,33,"VARTA","VAR-740500120",194.10050000000001]
["BATERIA","007720220\n007720287","007721012",null,"007740038\n007740012","007720022","GLOBAL P",509436722,31,"Yuasa","YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR",500615250,32,"VOLTHOR - TAB","0330281/929 - VUT11",91.95,"NEWONEDRIVE",500662860,33,"VARTA","VAR-610404068",92.3262]
["BATERIA",null,null,"007720071",null,null,"MOTORBUS",503500992,32,"HELLA","HE0070",59.270400000000002,"2024-08-20","2999-12-31","MOTORBUS",503500992,33,"VOLTHOR - TAB","0319850/929 - VS75",65.55,"NASACAR",500615250]
["BATERIA",null,"007720162",null,null,null,"NASACAR",500615250,31,"VOLTHOR - TAB","0330301/929 - VU80J",62,"2024-08-20","2999-12-31","NEWONEDRIVE",500662860,32,"VARTA","VAR-570412063",62.828000000000003,"COPEROL",502021160,33,"Tudor","57024",63.3]
["BATERIA","007720311",null,null,"007710056",null,"GLOBAL P",509436722,31,"Yuasa","YBX5063",40.549000000000007,"2024-08-20","2999-12-31","NEWONEDRIVE",500662860,32,"VARTA","VAR-535106052",114.8327,"KRAULTI",502271450,33,"YUASA","YBX5063",53.37]
["BATERIA","007720261",null,null,null,null,"NASACAR",500615250,31,"VOLTHOR - TAB","0330303/929 - VU95J",78,"2024-08-20","2999-12-31","NEWONEDRIVE",500662860,32,"VARTA","VAR-605102080",91.491899999999987,"COPEROL",502021160,33,"Coperol","61047",96.6]
["BATERIA","007720329",null,null,null,null,"MOTORBUS",503500992,31,"Tudor","TK1050",132.65280000000001,"2024-08-20","2999-12-31","GLOBAL P",509436722,32,"Yuasa","YBX9020",133.30340000000001,"BOMBÓLEO",500046280,33,"MARELLI","",144.62]
["BATERIA","007720246",null,"007740178","007740111",null,"GLOBAL P",509436722,31,"Yuasa","YBX5020",95.992800000000003,"2024-08-20","2999-12-31","BOMBÓLEO",500046280,32,"MARELLI","",112.24,"NEWONEDRIVE",500662860,33,"VARTA","VAR-610402092",112.49460000000001]
["BATERIA",null,null,"007710015",null,null,"MOTORBUS",503500992,31,"Tudor","TF1202",98.783999999999992,"2024-08-20","2999-12-31","GLOBAL P",509436722,32,"Yuasa","YBX3665",101.16780000000001,"NEWONEDRIVE",500662860,33,"VARTA","VAR-620047078",101.3593]
["BATERIA","007720253",null,null,null,null,"GLOBAL P",509436722,31,"Yuasa","YBX5063",40.549000000000007,"2024-08-20","2999-12-31","NASACAR",500615250,32,"VOLTHOR - TAB","0330302/929 - VS54",46.12,"KRAULTI",502271450,33,"YUASA","YBX5063",53.37]

{"sheet":"Fornecedores","index":1,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[[0,2,0,3],[0,4,0,5],[0,6,0,7],[0,8,0,9],[0,10,0,11]]}
["Nome","NIF","BT",null,"RL",null,"Universo Algarve",null,"Universo Alentejo",null,"Universo Tejo"]
["NASACAR",500615250,22511,20082,22511,"06657 ",22511," 00991",2254,"04483",22511,"21677"]
["NEWONEDRIVE",500662860,22511,49365,22511,10004,22511," 39064",2254,"04516",22511,"22998"]
["COPEROL",502021160,22511,15456,22511,10000,22511,"00293 ",2254,"01504",22511,"20438 "]
["KRAULTI",502271450,22511,20213,22511,8024,22511,"0017",2254,"03627",22511,"21655"]
["GLOBAL P",509436722,22511,49333,22511,9997,22511,"01635",22511,49333,22511,"49333"]
["MOTORBUS",503500992,22511,16366,22511,8679,22511,"01499",2254,"04363",22511,"22040"]
["BOMBÓLEO",500046280,22511,6421,22511,6037,22511,"215",2254,"940",22511,"20398"]

{"sheet":"RefParts II","index":2,"n_rows":100,"n_cols":12,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["Ref Acordo","Nome Acordo","Empresa","Descrição Peça","CAE","Fornecedor","CFE","Marca Modelo","VUnit","Acordo","Data I","Data F"]
["CP04.2024.00001","CP04.2024: Baterias","BT","BATERIA","007720006.10","MOTORBUS","16366.10","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","BT","BATERIA","007720006.10","MOTORBUS","16366.10","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","BT","BATERIA","007720063.10","GLOBAL P","49333.10","Yuasa: YBX3017",74.299200000000013,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","BT","BATERIA","007720063.10","GLOBAL P","49333.10","VARTA: VAR-595402080",84.942099999999996,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","BT","BATERIA","007720063.10","NEWONEDRIVE","49365.10",null,null,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","BT","BATERIA","007720089.10","MOTORBUS","16366.10","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","BT","BATERIA","007720089.10","MOTORBUS","16366.10","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","BT","BATERIA","007720220.10","GLOBAL P","49333.10","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","BT","BATERIA","007720220.10","NASACAR","20082.10","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","BT","BATERIA","007720220.10","NEWONEDRIVE","49365.10","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","BT","BATERIA","007720287.10","GLOBAL P","49333.10","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","BT","BATERIA","007720287.10","NASACAR","20082.10","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","BT","BATERIA","007720287.10","NEWONEDRIVE","49365.10","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00009","CP04.2024: Baterias","BT","BATERIA","007720311.10","GLOBAL P","49333.10","Yuasa: YBX5063",40.549000000000007,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00009","CP04.2024: Baterias","BT","BATERIA","007720311.10","NEWONEDRIVE","49365.10","VARTA: VAR-535106052",114.8327,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00009","CP04.2024: Baterias","BT","BATERIA","007720311.10","KRAULTI","20213.10","YUASA: YBX5063",53.37,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00010","CP04.2024: Baterias","BT","BATERIA","007720261.10","NASACAR","20082.10","VOLTHOR - TAB: 0330303/929 - VU95J",78,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00010","CP04.2024: Baterias","BT","BATERIA","007720261.10","NEWONEDRIVE","49365.10","VARTA: VAR-605102080",91.491899999999987,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00010","CP04.2024: Baterias","BT","BATERIA","007720261.10","COPEROL","15456.10","Coperol: 61047",96.6,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00011","CP04.2024: Baterias","BT","BATERIA","007720329.10","MOTORBUS","16366.10","Tudor: TK1050",132.65280000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00011","CP04.2024: Baterias","BT","BATERIA","007720329.10","GLOBAL P","49333.10","Yuasa: YBX9020",133.30340000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00011","CP04.2024: Baterias","BT","BATERIA","007720329.10","BOMBÓLEO","6421.10","MARELLI: ",144.62,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","BT","BATERIA","007720246.10","GLOBAL P","49333.10","Yuasa: YBX5020",95.992800000000003,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","BT","BATERIA","007720246.10","BOMBÓLEO","6421.10","MARELLI: ",112.24,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","BT","BATERIA","007720246.10","NEWONEDRIVE","49365.10","VARTA: VAR-610402092",112.49460000000001,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00014","CP04.2024: Baterias","BT","BATERIA","007720253.10","GLOBAL P","49333.10","Yuasa: YBX5063",40.549000000000007,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00014","CP04.2024: Baterias","BT","BATERIA","007720253.10","NASACAR","20082.10","VOLTHOR - TAB: 0330302/929 - VS54",46.12,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00014","CP04.2024: Baterias","BT","BATERIA","007720253.10","KRAULTI","20213.10","YUASA: YBX5063",53.37,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RL","BATERIA","007720063.16","MOTORBUS","8679.16","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RL","BATERIA","007720063.16","MOTORBUS","8679.16","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RL","BATERIA","007720204.16","MOTORBUS","8679.16","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RL","BATERIA","007720204.16","MOTORBUS","8679.16","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00005","CP04.2024: Baterias","RL","BATERIA","007721004.16","GLOBAL P"," 09997.16","Yuasa: YBX5625",190.49979999999999,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00005","CP04.2024: Baterias","RL","BATERIA","007721004.16","MOTORBUS","8679.16","TUDOR: TE2353",192.864,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00005","CP04.2024: Baterias","RL","BATERIA","007721004.16","NEWONEDRIVE","10004.16","VARTA: VAR-740500120",194.10050000000001,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RL","BATERIA","007721012.16","GLOBAL P"," 09997.16","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RL","BATERIA","007721012.16","NASACAR"," 06657 .16","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RL","BATERIA","007721012.16","NEWONEDRIVE","10004.16","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00008","CP04.2024: Baterias","RL","BATERIA","007720162.16","NASACAR"," 06657 .16","VOLTHOR - TAB: 0330301/929 - VU80J",62,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00008","CP04.2024: Baterias","RL","BATERIA","007720162.16","NEWONEDRIVE","10004.16","VARTA: VAR-570412063",62.828000000000003,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00008","CP04.2024: Baterias","RL","BATERIA","007720162.16","COPEROL"," 10000.16","Tudor: 57024",63.3,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","EVA","BATERIA","007720014.9","MOTORBUS","01499.9","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","EVA","BATERIA","007720014.9","MOTORBUS","01499.9","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","EVA","BATERIA","007720022.9","GLOBAL P"," 01635.9","Yuasa: YBX3017",74.299200000000013,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","EVA","BATERIA","007720022.9","GLOBAL P"," 01635.9","VARTA: VAR-595402080",84.942099999999996,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","EVA","BATERIA","007720022.9","NEWONEDRIVE"," 39064.9",null,null,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","EVA","BATERIA","007720048.9","MOTORBUS"," 01499.9","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","EVA","BATERIA","007720048.9","MOTORBUS"," 01499.9","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","EVA","BATERIA","007710049.9","MOTORBUS"," 01499.9","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","EVA","BATERIA","007710049.9","MOTORBUS"," 01499.9","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00007","CP04.2024: Baterias","EVA","BATERIA","007720071.9","MOTORBUS"," 01499.9","HELLA: HE0070",59.270400000000002,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00007","CP04.2024: Baterias","EVA","BATERIA","007720071.9","MOTORBUS"," 01499.9","VOLTHOR - TAB: 0319850/929 - VS75",65.55,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00007","CP04.2024: Baterias","EVA","BATERIA","007720071.9","NASACAR"," 00991.9",null,null,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","EVA","BATERIA","007740178.9","GLOBAL P"," 01635.9","Yuasa: YBX5020",95.992800000000003,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","EVA","BATERIA","007740178.9","BOMBÓLEO","215.9","MARELLI: ",112.24,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","EVA","BATERIA","007740178.9","NEWONEDRIVE"," 39064.9","VARTA: VAR-610402092",112.49460000000001,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00013","CP04.2024: Baterias","EVA","BATERIA","007710015.9","MOTORBUS"," 01499.9","Tudor: TF1202",98.783999999999992,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00013","CP04.2024: Baterias","EVA","BATERIA","007710015.9","GLOBAL P"," 01635.9","Yuasa: YBX3665",101.16780000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00013","CP04.2024: Baterias","EVA","BATERIA","007710015.9","NEWONEDRIVE"," 39064.9","VARTA: VAR-620047078",101.3593,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RA","BATERIA","007720063.8","MOTORBUS"," 04363.8","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RA","BATERIA","007720063.8","MOTORBUS"," 04363.8","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RA","BATERIA","007760010.8","MOTORBUS"," 04363.8","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RA","BATERIA","007760010.8","MOTORBUS"," 04363.8","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","RA","BATERIA","007720048.8","GLOBAL P","49333.8","Yuasa: YBX3017",74.299200000000013,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","RA","BATERIA","007720048.8","GLOBAL P","49333.8","VARTA: VAR-595402080",84.942099999999996,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00002","CP04.2024: Baterias","RA","BATERIA","007720048.8","NEWONEDRIVE"," 04516.8",null,null,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00003","CP04.2024: Baterias","RA","BATERIA","007720170.8","GLOBAL P","49333.8","Yuasa: YBX3019",77.689399999999992,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00003","CP04.2024: Baterias","RA","BATERIA","007720170.8","NASACAR","04483.8","VOLTHOR - TAB: 0330130/929 - VS11H",99.15,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00003","CP04.2024: Baterias","RA","BATERIA","007720170.8","KRAULTI","03627.8","YUASA: YBX3019",102.26,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RA","BATERIA","007740020.8","MOTORBUS"," 04363.8","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RA","BATERIA","007740020.8","MOTORBUS"," 04363.8","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RA","BATERIA","007740129.8","MOTORBUS"," 04363.8","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RA","BATERIA","007740129.8","MOTORBUS"," 04363.8","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RA","BATERIA","007740038.8","GLOBAL P","49333.8","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RA","BATERIA","007740038.8","NASACAR"," 04483.8","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RA","BATERIA","007740038.8","NEWONEDRIVE"," 04516.8","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RA","BATERIA","007740012.8","GLOBAL P","49333.8","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RA","BATERIA","007740012.8","NASACAR"," 04483.8","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RA","BATERIA","007740012.8","NEWONEDRIVE"," 04516.8","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00009","CP04.2024: Baterias","RA","BATERIA","007710056.8","GLOBAL P","49333.8","Yuasa: YBX5063",40.549000000000007,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00009","CP04.2024: Baterias","RA","BATERIA","007710056.8","NEWONEDRIVE"," 04516.8","VARTA: VAR-535106052",114.8327,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00009","CP04.2024: Baterias","RA","BATERIA","007710056.8","KRAULTI","03627.8","YUASA: YBX5063",53.37,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","RA","BATERIA","007740111.8","GLOBAL P","49333.8","Yuasa: YBX5020",95.992800000000003,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","RA","BATERIA","007740111.8","BOMBÓLEO","940.8","MARELLI: ",112.24,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00012","CP04.2024: Baterias","RA","BATERIA","007740111.8","NEWONEDRIVE"," 04516.8","VARTA: VAR-610402092",112.49460000000001,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RT","BATERIA","007720063.4","MOTORBUS"," 22040.4","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","RT","BATERIA","007720063.4","MOTORBUS"," 22040.4","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RT","BATERIA","00772097.4","MOTORBUS"," 22040.4","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","RT","BATERIA","00772097.4","MOTORBUS"," 22040.4","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RT","BATERIA","007720022.4","GLOBAL P","49333.4","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RT","BATERIA","007720022.4","NASACAR"," 21677.4","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","RT","BATERIA","007720022.4","NEWONEDRIVE"," 22998.4","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","ROeste","BATERIA","007720063.84","MOTORBUS"," 22040.84","HELLA: HE3225",159.93599999999998,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00001","CP04.2024: Baterias","ROeste","BATERIA","007720063.84","MOTORBUS"," 22040.84","NEWONEDRIVE: 500662860",33,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","ROeste","BATERIA","00772097.84","MOTORBUS"," 22040.84","HELLA: HE3180",127.00800000000001,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00004","CP04.2024: Baterias","ROeste","BATERIA","00772097.84","MOTORBUS"," 22040.84","Yuasa: YBX1629",130.51580000000001,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","ROeste","BATERIA","007720022.84","GLOBAL P","49333.84","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"Acordo","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","ROeste","BATERIA","007720022.84","NASACAR"," 21677.84","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"Alternativa 1","2024-08-20","2999-12-31"]
["CP04.2024.00006","CP04.2024: Baterias","ROeste","BATERIA","007720022.84","NEWONEDRIVE"," 22998.84","VARTA: VAR-610404068",92.3262,"Alternativa 2","2024-08-20","2999-12-31"]

{"sheet":"RefParts","index":3,"n_rows":39,"n_cols":19,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
["Ref Acordo","Nome Acordo","Empresa","Descrição Peça","CAE","Acodro: Fornecedor","Acordo: CFE","Acordo: Marca Modelo","Acordo: VUnit","Acordo: Data I","Acordo: Data F","Alt1: Fornecedor","Alt1: CFE","Alt1: Marca Modelo","Alt1: VUnit","Alt2: Fornecedor","Alt2: CFE","Alt2: Marca Modelo","Alt2: VUnit"]
["CP04.00001","CP04: Baterias","BT","BATERIA","007720006.10","MOTORBUS","16366.10","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS","16366.10","NEWONEDRIVE: 500662860",33]
["CP04.00002","CP04: Baterias","BT","BATERIA","007720063.10","GLOBAL P","49333.10","Yuasa: YBX3017",74.299200000000013,"2024-08-20","2999-12-31","GLOBAL P","49333.10","VARTA: VAR-595402080",84.942099999999996,"NEWONEDRIVE","49365.10"]
["CP04.00004","CP04: Baterias","BT","BATERIA","007720089.10","MOTORBUS","16366.10","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS","16366.10","Yuasa: YBX1629",130.51580000000001]
["CP04.00006","CP04: Baterias","BT","BATERIA","007720220.10","GLOBAL P","49333.10","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR","20082.10","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE","49365.10","VARTA: VAR-610404068",92.3262]
["CP04.00006","CP04: Baterias","BT","BATERIA","007720287.10","GLOBAL P","49333.10","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR","20082.10","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE","49365.10","VARTA: VAR-610404068",92.3262]
["CP04.00009","CP04: Baterias","BT","BATERIA","007720311.10","GLOBAL P","49333.10","Yuasa: YBX5063",40.549000000000007,"2024-08-20","2999-12-31","NEWONEDRIVE","49365.10","VARTA: VAR-535106052",114.8327,"KRAULTI","20213.10","YUASA: YBX5063",53.37]
["CP04.00010","CP04: Baterias","BT","BATERIA","007720261.10","NASACAR","20082.10","VOLTHOR - TAB: 0330303/929 - VU95J",78,"2024-08-20","2999-12-31","NEWONEDRIVE","49365.10","VARTA: VAR-605102080",91.491899999999987,"COPEROL","15456.10","Coperol: 61047",96.6]
["CP04.00011","CP04: Baterias","BT","BATERIA","007720329.10","MOTORBUS","16366.10","Tudor: TK1050",132.65280000000001,"2024-08-20","2999-12-31","GLOBAL P","49333.10","Yuasa: YBX9020",133.30340000000001,"BOMBÓLEO","6421.10","MARELLI: ",144.62]
["CP04.00012","CP04: Baterias","BT","BATERIA","007720246.10","GLOBAL P","49333.10","Yuasa: YBX5020",95.992800000000003,"2024-08-20","2999-12-31","BOMBÓLEO","6421.10","MARELLI: ",112.24,"NEWONEDRIVE","49365.10","VARTA: VAR-610402092",112.49460000000001]
["CP04.00014","CP04: Baterias","BT","BATERIA","007720253.10","GLOBAL P","49333.10","Yuasa: YBX5063",40.549000000000007,"2024-08-20","2999-12-31","NASACAR","20082.10","VOLTHOR - TAB: 0330302/929 - VS54",46.12,"KRAULTI","20213.10","YUASA: YBX5063",53.37]
["CP04.00001","CP04: Baterias","RL","BATERIA","007720063.16","MOTORBUS","8679.16","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS","8679.16","NEWONEDRIVE: 500662860",33]
["CP04.00004","CP04: Baterias","RL","BATERIA","007720204.16","MOTORBUS","8679.16","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS","8679.16","Yuasa: YBX1629",130.51580000000001]
["CP04.00005","CP04: Baterias","RL","BATERIA","007721004.16","GLOBAL P"," 09997.16","Yuasa: YBX5625",190.49979999999999,"2024-08-20","2999-12-31","MOTORBUS","8679.16","TUDOR: TE2353",192.864,"NEWONEDRIVE","10004.16","VARTA: VAR-740500120",194.10050000000001]
["CP04.00006","CP04: Baterias","RL","BATERIA","007721012.16","GLOBAL P"," 09997.16","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR"," 06657 .16","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE","10004.16","VARTA: VAR-610404068",92.3262]
["CP04.00008","CP04: Baterias","RL","BATERIA","007720162.16","NASACAR"," 06657 .16","VOLTHOR - TAB: 0330301/929 - VU80J",62,"2024-08-20","2999-12-31","NEWONEDRIVE","10004.16","VARTA: VAR-570412063",62.828000000000003,"COPEROL"," 10000.16","Tudor: 57024",63.3]
["CP04.00001","CP04: Baterias","EVA","BATERIA","007720014 .9","MOTORBUS"," 01499.9","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS"," 01499.9","NEWONEDRIVE: 500662860",33]
["CP04.00002","CP04: Baterias","EVA","BATERIA","007720022.9","GLOBAL P"," 01635.9","Yuasa: YBX3017",74.299200000000013,"2024-08-20","2999-12-31","GLOBAL P"," 01635.9","VARTA: VAR-595402080",84.942099999999996,"NEWONEDRIVE"," 39064.9"]
["CP04.00004","CP04: Baterias","EVA","BATERIA","007720048.9","MOTORBUS"," 01499.9","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS"," 01499.9","Yuasa: YBX1629",130.51580000000001]
["CP04.00004","CP04: Baterias","EVA","BATERIA","007710049.9","MOTORBUS"," 01499.9","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS"," 01499.9","Yuasa: YBX1629",130.51580000000001]
["CP04.00007","CP04: Baterias","EVA","BATERIA","007720071.9","MOTORBUS"," 01499.9","HELLA: HE0070",59.270400000000002,"2024-08-20","2999-12-31","MOTORBUS"," 01499.9","VOLTHOR - TAB: 0319850/929 - VS75",65.55,"NASACAR"," 00991.9"]
["CP04.00012","CP04: Baterias","EVA","BATERIA","007740178.9","GLOBAL P"," 01635.9","Yuasa: YBX5020",95.992800000000003,"2024-08-20","2999-12-31","BOMBÓLEO","215.9","MARELLI: ",112.24,"NEWONEDRIVE"," 39064.9","VARTA: VAR-610402092",112.49460000000001]
["CP04.00013","CP04: Baterias","EVA","BATERIA","007710015.9","MOTORBUS"," 01499.9","Tudor: TF1202",98.783999999999992,"2024-08-20","2999-12-31","GLOBAL P"," 01635.9","Yuasa: YBX3665",101.16780000000001,"NEWONEDRIVE"," 39064.9","VARTA: VAR-620047078",101.3593]
["CP04.00001","CP04: Baterias","RA","BATERIA","007720063.8","MOTORBUS"," 04363.8","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS"," 04363.8","NEWONEDRIVE: 500662860",33]
["CP04.00001","CP04: Baterias","RA","BATERIA","007760010.8","MOTORBUS"," 04363.8","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS"," 04363.8","NEWONEDRIVE: 500662860",33]
["CP04.00002","CP04: Baterias","RA","BATERIA","007720048.8","GLOBAL P","49333.8","Yuasa: YBX3017",74.299200000000013,"2024-08-20","2999-12-31","GLOBAL P","49333.8","VARTA: VAR-595402080",84.942099999999996,"NEWONEDRIVE"," 04516.8"]
["CP04.00003","CP04: Baterias","RA","BATERIA","007720170 .8","GLOBAL P","49333.8","Yuasa: YBX3019",77.689399999999992,"2024-08-20","2999-12-31","NASACAR"," 04483.8","VOLTHOR - TAB: 0330130/929 - VS11H",99.15,"KRAULTI","03627.8","YUASA: YBX3019",102.26]
["CP04.00004","CP04: Baterias","RA","BATERIA","007740020.8","MOTORBUS"," 04363.8","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS"," 04363.8","Yuasa: YBX1629",130.51580000000001]
["CP04.00004","CP04: Baterias","RA","BATERIA","007740129.8","MOTORBUS"," 04363.8","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS"," 04363.8","Yuasa: YBX1629",130.51580000000001]
["CP04.00006","CP04: Baterias","RA","BATERIA","007740038.8","GLOBAL P","49333.8","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR"," 04483.8","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE"," 04516.8","VARTA: VAR-610404068",92.3262]
["CP04.00006","CP04: Baterias","RA","BATERIA","007740012.8","GLOBAL P","49333.8","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR"," 04483.8","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE"," 04516.8","VARTA: VAR-610404068",92.3262]
["CP04.00009","CP04: Baterias","RA","BATERIA","007710056.8","GLOBAL P","49333.8","Yuasa: YBX5063",40.549000000000007,"2024-08-20","2999-12-31","NEWONEDRIVE"," 04516.8","VARTA: VAR-535106052",114.8327,"KRAULTI","03627.8","YUASA: YBX5063",53.37]
["CP04.00012","CP04: Baterias","RA","BATERIA","007740111.8","GLOBAL P","49333.8","Yuasa: YBX5020",95.992800000000003,"2024-08-20","2999-12-31","BOMBÓLEO","940.8","MARELLI: ",112.24,"NEWONEDRIVE"," 04516.8","VARTA: VAR-610402092",112.49460000000001]
["CP04.00001","CP04: Baterias","RT","BATERIA","007720063.4","MOTORBUS"," 22040.4","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS"," 22040.4","NEWONEDRIVE: 500662860",33]
["CP04.00004","CP04: Baterias","RT","BATERIA","00772097.4","MOTORBUS"," 22040.4","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS"," 22040.4","Yuasa: YBX1629",130.51580000000001]
["CP04.00006","CP04: Baterias","RT","BATERIA","007720022.4","GLOBAL P","49333.4","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR"," 21677.4","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE"," 22998.4","VARTA: VAR-610404068",92.3262]
["CP04.00001","CP04: Baterias","ROeste","BATERIA","007720063.84","MOTORBUS"," 22040.84","HELLA: HE3225",159.93599999999998,"2024-08-20","2999-12-31","MOTORBUS"," 22040.84","NEWONEDRIVE: 500662860",33]
["CP04.00004","CP04: Baterias","ROeste","BATERIA","00772097.84","MOTORBUS"," 22040.84","HELLA: HE3180",127.00800000000001,"2024-08-20","2999-12-31","MOTORBUS"," 22040.84","Yuasa: YBX1629",130.51580000000001]
["CP04.00006","CP04: Baterias","ROeste","BATERIA","007720022.84","GLOBAL P","49333.84","Yuasa: YBX1663 (não tem abas)",85.629000000000005,"2024-08-20","2999-12-31","NASACAR"," 21677.84","VOLTHOR - TAB: 0330281/929 - VUT11",91.95,"NEWONEDRIVE"," 22998.84","VARTA: VAR-610404068",92.3262]

{"sheet":"Fornecedores II","index":4,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Empresa","Nome","CFE","NIF"]
["BT","NASACAR","20082.10",500615250]
["BT","NEWONEDRIVE","49365.10",500662860]
["BT","COPEROL","15456.10",502021160]
["BT","KRAULTI","20213.10",502271450]
["BT","GLOBAL P","49333.10",509436722]
["BT","MOTORBUS","16366.10",503500992]
["BT","BOMBÓLEO","6421.10",500046280]
["RL","NASACAR","06657 .16",500615250]
["RL","NEWONEDRIVE","10004.16",500662860]
["RL","COPEROL","10000.16",502021160]
["RL","KRAULTI","8024.16",502271450]
["RL","GLOBAL P","9997.16",509436722]
["RL","MOTORBUS","8679.16",503500992]
["RL","BOMBÓLEO","6037.16",500046280]
["EVA","NASACAR"," 00991.9",500615250]
["EVA","NEWONEDRIVE"," 39064.9",500662860]
["EVA","COPEROL","00293 .9",502021160]
["EVA","KRAULTI","0017.9",502271450]
["EVA","GLOBAL P","01635.9",509436722]
["EVA","MOTORBUS","01499.9",503500992]
["EVA","BOMBÓLEO","215.9",500046280]
["RA","NASACAR","04483.8",500615250]
["RA","NEWONEDRIVE","04516.8",500662860]
["RA","COPEROL","01504.8",502021160]
["RA","KRAULTI","03627.8",502271450]
["RA","GLOBAL P","49333.8",509436722]
["RA","MOTORBUS","04363.8",503500992]
["RA","BOMBÓLEO","940.8",500046280]
["RT","NASACAR","21677.4",500615250]
["RT","NEWONEDRIVE","22998.4",500662860]
["RT","COPEROL","20438 .4",502021160]
["RT","KRAULTI","21655.4",502271450]
["RT","GLOBAL P","49333.4",509436722]
["RT","MOTORBUS","22040.4",503500992]
["RT","BOMBÓLEO","20398.4",500046280]
["ROeste","NASACAR","21677.84",500615250]
["ROeste","NEWONEDRIVE","22998.84",500662860]
["ROeste","COPEROL","20438 .84",502021160]
["ROeste","KRAULTI","21655.84",502271450]
["ROeste","GLOBAL P","49333.84",509436722]
["ROeste","MOTORBUS","22040.84",503500992]
["ROeste","BOMBÓLEO","20398.84",500046280]

{"sheet":"Input","index":5,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Nome Concurso","CP04.2024","Baterias"]
[null,"Base Cod. Fornecedores","BT","RL","Universo Algarve","Universo Alentejo","Universo Tejo","Universo Tejo"]
[null,"Empresas","BT","RL","EVA","RA","RT","ROeste"]
[null,"Cod. Empresas",10,16,9,8,4,84]
[null,"Nº Empresas AS400",5,"começa na col","B",{"$f":"COLUMN(INDIRECT(E6&\"1\"))","v":2}]
[null,"Ref. Peças AS400","BT","RL","EVA","RA","TEJO","TEJO"]
[null,"Dimensão Propostas",6,"colunas"]